-- Script Date: 12.11.2014 20:45  - ErikEJ.SqlCeScripting version 3.5.2.43
CREATE TABLE [Tasks] (
    [id]          			INT            		IDENTITY (1, 1) NOT NULL,
	[index_number]          INT            						NOT NULL,
    [text]        			NVARCHAR (100)						NOT NULL,
	[added_date]    		DATETIME           					NOT NULL,
    [due_date]    			DATETIME           					NOT NULL,
    [priority]    			NUMERIC (1)    		DEFAULT ((1)) 	NOT NULL,
    [actual_date] 			DATETIME           	DEFAULT (NULL) 	NULL
);
GO
ALTER TABLE [Tasks] ADD CONSTRAINT [PK_Tasks] PRIMARY KEY ([id]);
GO